| ColumnName |
Domain |
Datatype |
NULL |
Definition |
| Build |
|
int |
NO |
DBTeam application build version. |
| TouchedBy |
|
varchar(50) |
NO |
User ID of the person who is updating the data. |
| TouchedWhenUTC |
|
datetimeoffset(3) |
NO |
Data and time when the data was updated / modified. |
| CreatedBy |
|
varchar(50) |
NO |
User ID of the person who is inserting the data. |
| CreatedWhenUTC |
|
datetimeoffset(3) |
NO |
Data and time when the data was inserted / added. |
| MSRowVersion |
|
timestamp |
NO |
Optimistic lock identifier |
| MSReplrowguid |
|
uniqueidentifier |
NO |
Unique identifier in order to support Merge replication |
| Active |
|
bit |
NO |
Indicator whether selected row is currently active. |
HomeMedicationCollectionStatusID |
|
bigint |
NO |
Primary key |
ClientGUID |
|
HVCIDdt |
NO |
The GUID to identify the patient associated with this home medication collection |
| VisitGUID |
|
HVCIDdt |
NO |
The GUID to identify the visit in which the home medication collection was performed. |
| CollectionStatusType |
|
int |
NO |
Indicates if the medication review has been completed |
| UpdatedByUserGUID |
|
HVCIDdt |
NO |
The GUID of the user performing the medication collection |
| UpdatedUTC |
|
datetimeoffset(3) |
NO |
The date when the home medication status was saved
|
| NEHRPMLCollectionStatusType |
|
int |
NO |
whether the PML collection is complete |